Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 24847481 |
| Missing cells | 3611267 |
| Missing cells (%) | 0.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 21.0 GiB |
| Average record size in memory | 908.3 B |
Variable types
| Text | 9 |
|---|---|
| DateTime | 1 |
| Numeric | 12 |
| Unsupported | 2 |
Store Location has 2450072 (9.9%) missing values | Missing |
County Number has 714638 (2.9%) missing values | Missing |
Bottle Volume (ml) is highly skewed (γ1 = 207.8010243) | Skewed |
State Bottle Cost is highly skewed (γ1 = 183.009033) | Skewed |
State Bottle Retail is highly skewed (γ1 = 183.0325335) | Skewed |
Bottles Sold is highly skewed (γ1 = 65.3044445) | Skewed |
Sale (Dollars) is highly skewed (γ1 = 88.29524725) | Skewed |
Volume Sold (Liters) is highly skewed (γ1 = 65.33839987) | Skewed |
Volume Sold (Gallons) is highly skewed (γ1 = 65.33652904) | Skewed |
Invoice/Item Number has unique values | Unique |
Zip Code is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Item Number is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-08-09 23:59:51.990494 |
|---|---|
| Analysis finished | 2024-08-10 00:24:47.211526 |
| Duration | 24 minutes and 55.22 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
UNIQUE 
| Distinct | 24847481 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.6 GiB |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 13.807005 |
| Min length | 9 |
Characters and Unicode
| Total characters | 343069303 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 24847481 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | INV-16589800035 |
|---|---|
| 2nd row | INV-16669000029 |
| 3rd row | INV-16624000064 |
| 4th row | INV-16610400055 |
| 5th row | INV-16575300022 |
| Value | Count | Frequency (%) |
| inv-16639800026 | 1 | < 0.1% |
| inv-16619600095 | 1 | < 0.1% |
| inv-16589800035 | 1 | < 0.1% |
| inv-16669000029 | 1 | < 0.1% |
| inv-16624000064 | 1 | < 0.1% |
| inv-16610400055 | 1 | < 0.1% |
| inv-16575300022 | 1 | < 0.1% |
| inv-16623300001 | 1 | < 0.1% |
| inv-16615400044 | 1 | < 0.1% |
| inv-16676400069 | 1 | < 0.1% |
| Other values (24847471) | 24847471 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 98476952 | |
| 1 | 29326157 | 8.5% |
| 2 | 25533278 | 7.4% |
| 3 | 22064596 | 6.4% |
| 4 | 19126161 | 5.6% |
| 5 | 16856716 | 4.9% |
| 6 | 16030662 | 4.7% |
| 7 | 15555848 | 4.5% |
| 8 | 15283674 | 4.5% |
| 9 | 15069782 | 4.4% |
| Other values (6) | 69745477 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 343069303 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 98476952 | |
| 1 | 29326157 | 8.5% |
| 2 | 25533278 | 7.4% |
| 3 | 22064596 | 6.4% |
| 4 | 19126161 | 5.6% |
| 5 | 16856716 | 4.9% |
| 6 | 16030662 | 4.7% |
| 7 | 15555848 | 4.5% |
| 8 | 15283674 | 4.5% |
| 9 | 15069782 | 4.4% |
| Other values (6) | 69745477 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 343069303 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 98476952 | |
| 1 | 29326157 | 8.5% |
| 2 | 25533278 | 7.4% |
| 3 | 22064596 | 6.4% |
| 4 | 19126161 | 5.6% |
| 5 | 16856716 | 4.9% |
| 6 | 16030662 | 4.7% |
| 7 | 15555848 | 4.5% |
| 8 | 15283674 | 4.5% |
| 9 | 15069782 | 4.4% |
| Other values (6) | 69745477 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 343069303 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 98476952 | |
| 1 | 29326157 | 8.5% |
| 2 | 25533278 | 7.4% |
| 3 | 22064596 | 6.4% |
| 4 | 19126161 | 5.6% |
| 5 | 16856716 | 4.9% |
| 6 | 16030662 | 4.7% |
| 7 | 15555848 | 4.5% |
| 8 | 15283674 | 4.5% |
| 9 | 15069782 | 4.4% |
| Other values (6) | 69745477 |
Date
Date
| Distinct | 2730 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 189.6 MiB |
| Minimum | 2012-01-03 00:00:00 |
|---|---|
| Maximum | 2022-09-30 00:00:00 |
Store Number
Real number (ℝ)
| Distinct | 2807 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3786.0345 |
| Minimum | 2106 |
|---|---|
| Maximum | 10057 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | 2106 |
|---|---|
| 5-th percentile | 2506 |
| Q1 | 2619 |
| median | 3829 |
| Q3 | 4642 |
| 95-th percentile | 5600 |
| Maximum | 10057 |
| Range | 7951 |
| Interquartile range (IQR) | 2023 |
Descriptive statistics
| Standard deviation | 1104.2915 |
|---|---|
| Coefficient of variation (CV) | 0.29167497 |
| Kurtosis | -0.59070345 |
| Mean | 3786.0345 |
| Median Absolute Deviation (MAD) | 1172 |
| Skewness | 0.34019531 |
| Sum | 9.4073421 × 1010 |
| Variance | 1219459.8 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2633 | 205995 | 0.8% |
| 4829 | 173686 | 0.7% |
| 2190 | 163078 | 0.7% |
| 2512 | 139260 | 0.6% |
| 2572 | 131220 | 0.5% |
| 2603 | 128754 | 0.5% |
| 2515 | 124798 | 0.5% |
| 2614 | 124479 | 0.5% |
| 2647 | 120373 | 0.5% |
| 2648 | 119680 | 0.5% |
| Other values (2797) | 23416158 |
| Value | Count | Frequency (%) |
| 2106 | 46159 | 0.2% |
| 2113 | 11419 | < 0.1% |
| 2130 | 39072 | 0.2% |
| 2132 | 535 | < 0.1% |
| 2152 | 6649 | < 0.1% |
| 2161 | 566 | < 0.1% |
| 2178 | 23290 | 0.1% |
| 2190 | 163078 | |
| 2191 | 60926 | 0.2% |
| 2200 | 39148 | 0.2% |
| Value | Count | Frequency (%) |
| 10057 | 144 | < 0.1% |
| 10053 | 87 | < 0.1% |
| 10051 | 121 | < 0.1% |
| 10046 | 84 | < 0.1% |
| 10045 | 260 | < 0.1% |
| 10044 | 35 | < 0.1% |
| 10042 | 162 | < 0.1% |
| 10040 | 56 | < 0.1% |
| 10039 | 1610 | |
| 10037 | 694 |
Store Name
Text
| Distinct | 2972 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 GiB |
Length
| Max length | 58 |
|---|---|
| Median length | 42 |
| Mean length | 26.158078 |
| Min length | 4 |
Characters and Unicode
| Total characters | 649962354 |
|---|---|
| Distinct characters | 75 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Hy-Vee Food Store / Oskaloosa |
|---|---|
| 2nd row | Stewart Road Fast Break |
| 3rd row | Hy-Vee Food Store / Carroll |
| 4th row | Fareway Stores #909 / Ankeny |
| 5th row | Big G Food Store |
| Value | Count | Frequency (%) |
| 19402342 | 16.1% | |
| hy-vee | 8172944 | 6.8% |
| store | 5547356 | 4.6% |
| food | 4809433 | 4.0% |
| and | 3561175 | 3.0% |
| liquor | 3178494 | 2.6% |
| spirits | 2590565 | 2.1% |
| wine | 2188822 | 1.8% |
| city | 2006216 | 1.7% |
| cedar | 1472216 | 1.2% |
| Other values (2548) | 67614587 |
Most occurring characters
| Value | Count | Frequency (%) |
| 96494134 | 14.8% | |
| e | 56030548 | 8.6% |
| o | 44093308 | 6.8% |
| r | 36054932 | 5.5% |
| a | 31534722 | 4.9% |
| t | 28479887 | 4.4% |
| i | 27187115 | 4.2% |
| n | 23026225 | 3.5% |
| s | 21045699 | 3.2% |
| / | 17502571 | 2.7% |
| Other values (65) | 268513213 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 649962354 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 96494134 | 14.8% | |
| e | 56030548 | 8.6% |
| o | 44093308 | 6.8% |
| r | 36054932 | 5.5% |
| a | 31534722 | 4.9% |
| t | 28479887 | 4.4% |
| i | 27187115 | 4.2% |
| n | 23026225 | 3.5% |
| s | 21045699 | 3.2% |
| / | 17502571 | 2.7% |
| Other values (65) | 268513213 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 649962354 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 96494134 | 14.8% | |
| e | 56030548 | 8.6% |
| o | 44093308 | 6.8% |
| r | 36054932 | 5.5% |
| a | 31534722 | 4.9% |
| t | 28479887 | 4.4% |
| i | 27187115 | 4.2% |
| n | 23026225 | 3.5% |
| s | 21045699 | 3.2% |
| / | 17502571 | 2.7% |
| Other values (65) | 268513213 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 649962354 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 96494134 | 14.8% | |
| e | 56030548 | 8.6% |
| o | 44093308 | 6.8% |
| r | 36054932 | 5.5% |
| a | 31534722 | 4.9% |
| t | 28479887 | 4.4% |
| i | 27187115 | 4.2% |
| n | 23026225 | 3.5% |
| s | 21045699 | 3.2% |
| / | 17502571 | 2.7% |
| Other values (65) | 268513213 |
Address
Text
| Distinct | 4134 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 81913 |
| Missing (%) | 0.3% |
| Memory size | 1.7 GiB |
Length
| Max length | 55 |
|---|---|
| Median length | 32 |
| Mean length | 15.851496 |
| Min length | 8 |
Characters and Unicode
| Total characters | 392571292 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 110 S D St |
|---|---|
| 2nd row | 2418 Stewart Rd |
| 3rd row | 905 US Highway 30 West |
| 4th row | 109 SE Oralabor Rd |
| 5th row | Po Box 261 310 W Dillon |
| Value | Count | Frequency (%) |
| st | 8593247 | 9.7% |
| ave | 5173259 | 5.8% |
| e | 2034123 | 2.3% |
| rd | 2032702 | 2.3% |
| w | 1811805 | 2.0% |
| s | 1496868 | 1.7% |
| n | 1483308 | 1.7% |
| dr | 1467716 | 1.7% |
| se | 1231645 | 1.4% |
| main | 1210111 | 1.4% |
| Other values (1894) | 62112033 |
Most occurring characters
| Value | Count | Frequency (%) |
| 66158967 | 16.9% | |
| 1 | 23363309 | 6.0% |
| 0 | 18649626 | 4.8% |
| S | 18056666 | 4.6% |
| t | 14873854 | 3.8% |
| 2 | 13310956 | 3.4% |
| E | 12815806 | 3.3% |
| e | 12453780 | 3.2% |
| A | 11632097 | 3.0% |
| 5 | 9692813 | 2.5% |
| Other values (60) | 191563418 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 392571292 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 66158967 | 16.9% | |
| 1 | 23363309 | 6.0% |
| 0 | 18649626 | 4.8% |
| S | 18056666 | 4.6% |
| t | 14873854 | 3.8% |
| 2 | 13310956 | 3.4% |
| E | 12815806 | 3.3% |
| e | 12453780 | 3.2% |
| A | 11632097 | 3.0% |
| 5 | 9692813 | 2.5% |
| Other values (60) | 191563418 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 392571292 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 66158967 | 16.9% | |
| 1 | 23363309 | 6.0% |
| 0 | 18649626 | 4.8% |
| S | 18056666 | 4.6% |
| t | 14873854 | 3.8% |
| 2 | 13310956 | 3.4% |
| E | 12815806 | 3.3% |
| e | 12453780 | 3.2% |
| A | 11632097 | 3.0% |
| 5 | 9692813 | 2.5% |
| Other values (60) | 191563418 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 392571292 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 66158967 | 16.9% | |
| 1 | 23363309 | 6.0% |
| 0 | 18649626 | 4.8% |
| S | 18056666 | 4.6% |
| t | 14873854 | 3.8% |
| 2 | 13310956 | 3.4% |
| E | 12815806 | 3.3% |
| e | 12453780 | 3.2% |
| A | 11632097 | 3.0% |
| 5 | 9692813 | 2.5% |
| Other values (60) | 191563418 |
City
Text
| Distinct | 859 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 81912 |
| Missing (%) | 0.3% |
| Memory size | 1.5 GiB |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 9.1979476 |
| Min length | 3 |
Characters and Unicode
| Total characters | 227792406 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Oskaloosa |
|---|---|
| 2nd row | Muscatine |
| 3rd row | Carroll |
| 4th row | Ankeny |
| 5th row | Marengo |
| Value | Count | Frequency (%) |
| des | 2845492 | 7.9% |
| moines | 2845492 | 7.9% |
| city | 2202300 | 6.1% |
| cedar | 2110848 | 5.8% |
| rapids | 1681705 | 4.7% |
| davenport | 1066185 | 3.0% |
| west | 865098 | 2.4% |
| sioux | 791761 | 2.2% |
| waterloo | 780243 | 2.2% |
| iowa | 763989 | 2.1% |
| Other values (482) | 20176657 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 14916536 | 6.5% |
| 11364201 | 5.0% | |
| o | 11147155 | 4.9% |
| a | 10607823 | 4.7% |
| n | 10011793 | 4.4% |
| s | 9316873 | 4.1% |
| E | 9007701 | 4.0% |
| i | 8963399 | 3.9% |
| A | 8122206 | 3.6% |
| C | 7904330 | 3.5% |
| Other values (46) | 126430389 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 227792406 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 14916536 | 6.5% |
| 11364201 | 5.0% | |
| o | 11147155 | 4.9% |
| a | 10607823 | 4.7% |
| n | 10011793 | 4.4% |
| s | 9316873 | 4.1% |
| E | 9007701 | 4.0% |
| i | 8963399 | 3.9% |
| A | 8122206 | 3.6% |
| C | 7904330 | 3.5% |
| Other values (46) | 126430389 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 227792406 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 14916536 | 6.5% |
| 11364201 | 5.0% | |
| o | 11147155 | 4.9% |
| a | 10607823 | 4.7% |
| n | 10011793 | 4.4% |
| s | 9316873 | 4.1% |
| E | 9007701 | 4.0% |
| i | 8963399 | 3.9% |
| A | 8122206 | 3.6% |
| C | 7904330 | 3.5% |
| Other values (46) | 126430389 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 227792406 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 14916536 | 6.5% |
| 11364201 | 5.0% | |
| o | 11147155 | 4.9% |
| a | 10607823 | 4.7% |
| n | 10011793 | 4.4% |
| s | 9316873 | 4.1% |
| E | 9007701 | 4.0% |
| i | 8963399 | 3.9% |
| A | 8122206 | 3.6% |
| C | 7904330 | 3.5% |
| Other values (46) | 126430389 |
Zip Code
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 81957 |
|---|---|
| Missing (%) | 0.3% |
| Memory size | 1.1 GiB |
Store Location
Text
MISSING 
| Distinct | 3203 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2450072 |
| Missing (%) | 9.9% |
| Memory size | 1.9 GiB |
Length
| Max length | 45 |
|---|---|
| Median length | 28 |
| Mean length | 28.848594 |
| Min length | 23 |
Characters and Unicode
| Total characters | 646133761 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | POINT (-92.649764 41.295218) |
|---|---|
| 2nd row | POINT (-91.07265200000002 41.390911) |
| 3rd row | POINT (-94.853591 42.064155) |
| 4th row | POINT (-93.59949600000002 41.702811) |
| 5th row | POINT (-94.377667 42.026833) |
| Value | Count | Frequency (%) |
| point | 22397409 | |
| 93.596754 | 189532 | 0.3% |
| 41.554101 | 189532 | 0.3% |
| 93.613739 | 155441 | 0.2% |
| 41.60572 | 155441 | 0.2% |
| 93.619787 | 151647 | 0.2% |
| 41.60566 | 151647 | 0.2% |
| 42.512789 | 131216 | 0.2% |
| 92.435236 | 131216 | 0.2% |
| 91.53046300000001 | 131200 | 0.2% |
| Other values (5932) | 43407946 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4 | 50476897 | 7.8% |
| 0 | 47062048 | 7.3% |
| 9 | 46185792 | 7.1% |
| 1 | 45904070 | 7.1% |
| . | 44794818 | 6.9% |
| 44794818 | 6.9% | |
| 2 | 35257191 | 5.5% |
| 3 | 34526189 | 5.3% |
| 5 | 33797112 | 5.2% |
| 6 | 31973632 | 4.9% |
| Other values (10) | 231361194 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 646133761 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 4 | 50476897 | 7.8% |
| 0 | 47062048 | 7.3% |
| 9 | 46185792 | 7.1% |
| 1 | 45904070 | 7.1% |
| . | 44794818 | 6.9% |
| 44794818 | 6.9% | |
| 2 | 35257191 | 5.5% |
| 3 | 34526189 | 5.3% |
| 5 | 33797112 | 5.2% |
| 6 | 31973632 | 4.9% |
| Other values (10) | 231361194 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 646133761 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 4 | 50476897 | 7.8% |
| 0 | 47062048 | 7.3% |
| 9 | 46185792 | 7.1% |
| 1 | 45904070 | 7.1% |
| . | 44794818 | 6.9% |
| 44794818 | 6.9% | |
| 2 | 35257191 | 5.5% |
| 3 | 34526189 | 5.3% |
| 5 | 33797112 | 5.2% |
| 6 | 31973632 | 4.9% |
| Other values (10) | 231361194 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 646133761 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 4 | 50476897 | 7.8% |
| 0 | 47062048 | 7.3% |
| 9 | 46185792 | 7.1% |
| 1 | 45904070 | 7.1% |
| . | 44794818 | 6.9% |
| 44794818 | 6.9% | |
| 2 | 35257191 | 5.5% |
| 3 | 34526189 | 5.3% |
| 5 | 33797112 | 5.2% |
| 6 | 31973632 | 4.9% |
| Other values (10) | 231361194 |
County Number
Real number (ℝ)
MISSING 
| Distinct | 99 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 714638 |
| Missing (%) | 2.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 57.259133 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 31 |
| median | 62 |
| Q3 | 77 |
| 95-th percentile | 94 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 46 |
Descriptive statistics
| Standard deviation | 27.287104 |
|---|---|
| Coefficient of variation (CV) | 0.47655462 |
| Kurtosis | -0.94931404 |
| Mean | 57.259133 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | -0.53944166 |
| Sum | 1.3818257 × 109 |
| Variance | 744.58607 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 77 | 4459618 | |
| 57 | 2013416 | 8.1% |
| 82 | 1472224 | 5.9% |
| 7 | 1353303 | 5.4% |
| 52 | 1210494 | 4.9% |
| 78 | 796208 | 3.2% |
| 85 | 771807 | 3.1% |
| 97 | 755174 | 3.0% |
| 31 | 701537 | 2.8% |
| 17 | 533730 | 2.1% |
| Other values (89) | 10065332 | |
| (Missing) | 714638 | 2.9% |
| Value | Count | Frequency (%) |
| 1 | 50009 | 0.2% |
| 2 | 19865 | 0.1% |
| 3 | 99368 | 0.4% |
| 4 | 86089 | 0.3% |
| 5 | 26544 | 0.1% |
| 6 | 114142 | 0.5% |
| 7 | 1353303 | |
| 8 | 173668 | 0.7% |
| 9 | 187794 | 0.8% |
| 10 | 135565 | 0.5% |
| Value | Count | Frequency (%) |
| 99 | 69415 | 0.3% |
| 98 | 34253 | 0.1% |
| 97 | 755174 | |
| 96 | 122996 | 0.5% |
| 95 | 83972 | 0.3% |
| 94 | 274118 | 1.1% |
| 93 | 18725 | 0.1% |
| 92 | 147811 | 0.6% |
| 91 | 222011 | 0.9% |
| 90 | 278134 | 1.1% |
County
Text
| Distinct | 201 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 158715 |
| Missing (%) | 0.6% |
| Memory size | 1.5 GiB |
Length
| Max length | 13 |
|---|---|
| Median length | 10 |
| Mean length | 6.3615352 |
| Min length | 3 |
Characters and Unicode
| Total characters | 157058455 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | MAHASKA |
|---|---|
| 2nd row | MUSCATINE |
| 3rd row | CARROLL |
| 4th row | POLK |
| 5th row | IOWA |
| Value | Count | Frequency (%) |
| polk | 4568617 | 16.7% |
| linn | 2059315 | 7.5% |
| scott | 1502782 | 5.5% |
| black | 1383941 | 5.1% |
| hawk | 1383941 | 5.1% |
| johnson | 1236666 | 4.5% |
| story | 788339 | 2.9% |
| woodbury | 771923 | 2.8% |
| dubuque | 715855 | 2.6% |
| cerro | 544520 | 2.0% |
| Other values (101) | 12370083 |
Most occurring characters
| Value | Count | Frequency (%) |
| O | 10932567 | 7.0% |
| L | 8394015 | 5.3% |
| o | 8103942 | 5.2% |
| N | 7764016 | 4.9% |
| A | 7578533 | 4.8% |
| P | 6332829 | 4.0% |
| S | 6138724 | 3.9% |
| T | 5925866 | 3.8% |
| n | 5369048 | 3.4% |
| K | 5216964 | 3.3% |
| Other values (41) | 85301951 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 157058455 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| O | 10932567 | 7.0% |
| L | 8394015 | 5.3% |
| o | 8103942 | 5.2% |
| N | 7764016 | 4.9% |
| A | 7578533 | 4.8% |
| P | 6332829 | 4.0% |
| S | 6138724 | 3.9% |
| T | 5925866 | 3.8% |
| n | 5369048 | 3.4% |
| K | 5216964 | 3.3% |
| Other values (41) | 85301951 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 157058455 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| O | 10932567 | 7.0% |
| L | 8394015 | 5.3% |
| o | 8103942 | 5.2% |
| N | 7764016 | 4.9% |
| A | 7578533 | 4.8% |
| P | 6332829 | 4.0% |
| S | 6138724 | 3.9% |
| T | 5925866 | 3.8% |
| n | 5369048 | 3.4% |
| K | 5216964 | 3.3% |
| Other values (41) | 85301951 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 157058455 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| O | 10932567 | 7.0% |
| L | 8394015 | 5.3% |
| o | 8103942 | 5.2% |
| N | 7764016 | 4.9% |
| A | 7578533 | 4.8% |
| P | 6332829 | 4.0% |
| S | 6138724 | 3.9% |
| T | 5925866 | 3.8% |
| n | 5369048 | 3.4% |
| K | 5216964 | 3.3% |
| Other values (41) | 85301951 |
Category
Real number (ℝ)
| Distinct | 114 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 16974 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1049080.2 |
| Minimum | 101220 |
|---|---|
| Maximum | 1901200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | 101220 |
|---|---|
| 5-th percentile | 1011200 |
| Q1 | 1012200 |
| median | 1031200 |
| Q3 | 1062400 |
| 95-th percentile | 1082000 |
| Maximum | 1901200 |
| Range | 1799980 |
| Interquartile range (IQR) | 50200 |
Descriptive statistics
| Standard deviation | 78245.098 |
|---|---|
| Coefficient of variation (CV) | 0.074584478 |
| Kurtosis | 64.802301 |
| Mean | 1049080.2 |
| Median Absolute Deviation (MAD) | 19810 |
| Skewness | 7.6585159 |
| Sum | 2.6049193 × 1013 |
| Variance | 6.1222953 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1012100 | 2376643 | 9.6% |
| 1031100 | 2337813 | 9.4% |
| 1011200 | 1537217 | 6.2% |
| 1031080 | 1265974 | 5.1% |
| 1031200 | 1236935 | 5.0% |
| 1081600 | 1095653 | 4.4% |
| 1011100 | 1070908 | 4.3% |
| 1022100 | 758381 | 3.1% |
| 1062200 | 739758 | 3.0% |
| 1062400 | 704020 | 2.8% |
| Other values (104) | 11707205 |
| Value | Count | Frequency (%) |
| 101220 | 6 | < 0.1% |
| 1011000 | 1 | < 0.1% |
| 1011100 | 1070908 | |
| 1011200 | 1537217 | |
| 1011250 | 9268 | < 0.1% |
| 1011300 | 267674 | 1.1% |
| 1011400 | 417493 | 1.7% |
| 1011500 | 77896 | 0.3% |
| 1011600 | 110947 | 0.4% |
| 1011700 | 10223 | < 0.1% |
| Value | Count | Frequency (%) |
| 1901200 | 28045 | 0.1% |
| 1901100 | 63 | < 0.1% |
| 1901000 | 423 | < 0.1% |
| 1900000 | 1 | < 0.1% |
| 1701200 | 48 | < 0.1% |
| 1701100 | 247903 | |
| 1700000 | 17944 | 0.1% |
| 1501100 | 32 | < 0.1% |
| 1101100 | 24351 | 0.1% |
| 1092100 | 20473 | 0.1% |
Category Name
Text
| Distinct | 136 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 25040 |
| Missing (%) | 0.1% |
| Memory size | 1.7 GiB |
Length
| Max length | 36 |
|---|---|
| Median length | 34 |
| Mean length | 17.324517 |
| Min length | 6 |
Characters and Unicode
| Total characters | 430036803 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Straight Rye Whiskies |
|---|---|
| 2nd row | Imported Schnapps |
| 3rd row | Single Barrel Bourbon Whiskies |
| 4th row | Temporary & Specialty Packages |
| 5th row | Straight Rye Whiskies |
| Value | Count | Frequency (%) |
| whiskies | 6559168 | 10.8% |
| american | 5592758 | 9.2% |
| vodka | 3557828 | 5.8% |
| imported | 3191448 | 5.2% |
| rum | 2780252 | 4.6% |
| vodkas | 2724570 | 4.5% |
| canadian | 2376643 | 3.9% |
| flavored | 2256480 | 3.7% |
| 1999419 | 3.3% | |
| straight | 1707281 | 2.8% |
| Other values (100) | 28162235 |
Most occurring characters
| Value | Count | Frequency (%) |
| 36107834 | 8.4% | |
| i | 23566038 | 5.5% |
| e | 22403455 | 5.2% |
| a | 20761269 | 4.8% |
| I | 18042114 | 4.2% |
| A | 17967391 | 4.2% |
| s | 16752032 | 3.9% |
| S | 16400073 | 3.8% |
| r | 15293605 | 3.6% |
| R | 14051712 | 3.3% |
| Other values (48) | 228691280 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 430036803 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 36107834 | 8.4% | |
| i | 23566038 | 5.5% |
| e | 22403455 | 5.2% |
| a | 20761269 | 4.8% |
| I | 18042114 | 4.2% |
| A | 17967391 | 4.2% |
| s | 16752032 | 3.9% |
| S | 16400073 | 3.8% |
| r | 15293605 | 3.6% |
| R | 14051712 | 3.3% |
| Other values (48) | 228691280 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 430036803 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 36107834 | 8.4% | |
| i | 23566038 | 5.5% |
| e | 22403455 | 5.2% |
| a | 20761269 | 4.8% |
| I | 18042114 | 4.2% |
| A | 17967391 | 4.2% |
| s | 16752032 | 3.9% |
| S | 16400073 | 3.8% |
| r | 15293605 | 3.6% |
| R | 14051712 | 3.3% |
| Other values (48) | 228691280 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 430036803 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 36107834 | 8.4% | |
| i | 23566038 | 5.5% |
| e | 22403455 | 5.2% |
| a | 20761269 | 4.8% |
| I | 18042114 | 4.2% |
| A | 17967391 | 4.2% |
| s | 16752032 | 3.9% |
| S | 16400073 | 3.8% |
| r | 15293605 | 3.6% |
| R | 14051712 | 3.3% |
| Other values (48) | 228691280 |
Vendor Number
Real number (ℝ)
| Distinct | 428 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 9 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 266.71765 |
| Minimum | 10 |
|---|---|
| Maximum | 987 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 55 |
| Q1 | 115 |
| median | 260 |
| Q3 | 391 |
| 95-th percentile | 434 |
| Maximum | 987 |
| Range | 977 |
| Interquartile range (IQR) | 276 |
Descriptive statistics
| Standard deviation | 141.89777 |
|---|---|
| Coefficient of variation (CV) | 0.53201494 |
| Kurtosis | -0.034845742 |
| Mean | 266.71765 |
| Median Absolute Deviation (MAD) | 135 |
| Skewness | 0.022030204 |
| Sum | 6.6272593 × 109 |
| Variance | 20134.978 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 260 | 4127854 | |
| 65 | 2307531 | 9.3% |
| 434 | 2206741 | 8.9% |
| 421 | 1918825 | 7.7% |
| 370 | 1474144 | 5.9% |
| 259 | 1278543 | 5.1% |
| 35 | 1106048 | 4.5% |
| 115 | 1044480 | 4.2% |
| 55 | 1040215 | 4.2% |
| 395 | 960804 | 3.9% |
| Other values (418) | 7382287 |
| Value | Count | Frequency (%) |
| 10 | 1003 | < 0.1% |
| 14 | 1 | < 0.1% |
| 27 | 3 | < 0.1% |
| 33 | 23 | < 0.1% |
| 35 | 1106048 | |
| 51 | 1 | < 0.1% |
| 55 | 1040215 | |
| 61 | 11 | < 0.1% |
| 65 | 2307531 | |
| 68 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 987 | 31 | < 0.1% |
| 978 | 11891 | |
| 977 | 598 | < 0.1% |
| 971 | 15858 | |
| 969 | 1565 | < 0.1% |
| 962 | 3029 | < 0.1% |
| 892 | 5 | < 0.1% |
| 890 | 1 | < 0.1% |
| 888 | 401 | < 0.1% |
| 886 | 1133 | < 0.1% |
Vendor Name
Text
| Distinct | 585 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 7 |
| Missing (%) | < 0.1% |
| Memory size | 1.7 GiB |
Length
| Max length | 67 |
|---|---|
| Median length | 57 |
| Mean length | 17.958747 |
| Min length | 7 |
Characters and Unicode
| Total characters | 446229506 |
|---|---|
| Distinct characters | 71 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 49 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Infinium Spirits |
|---|---|
| 2nd row | SAZERAC COMPANY INC |
| 3rd row | Heaven Hill Brands |
| 4th row | DIAGEO AMERICAS |
| 5th row | Infinium Spirits |
| Value | Count | Frequency (%) |
| inc | 6432419 | 9.3% |
| brands | 4128875 | 5.9% |
| americas | 4128257 | 5.9% |
| diageo | 4127854 | 5.9% |
| company | 3495628 | 5.0% |
| sazerac | 2959040 | 4.3% |
| jim | 2307531 | 3.3% |
| beam | 2307531 | 3.3% |
| usa | 2009414 | 2.9% |
| pernod | 1474144 | 2.1% |
| Other values (715) | 36031084 |
Most occurring characters
| Value | Count | Frequency (%) |
| 46468880 | 10.4% | |
| A | 24969779 | 5.6% |
| a | 22762692 | 5.1% |
| i | 22639415 | 5.1% |
| C | 19673973 | 4.4% |
| r | 18469298 | 4.1% |
| n | 18328273 | 4.1% |
| e | 17600154 | 3.9% |
| I | 16960889 | 3.8% |
| o | 16726088 | 3.7% |
| Other values (61) | 221630065 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 446229506 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 46468880 | 10.4% | |
| A | 24969779 | 5.6% |
| a | 22762692 | 5.1% |
| i | 22639415 | 5.1% |
| C | 19673973 | 4.4% |
| r | 18469298 | 4.1% |
| n | 18328273 | 4.1% |
| e | 17600154 | 3.9% |
| I | 16960889 | 3.8% |
| o | 16726088 | 3.7% |
| Other values (61) | 221630065 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 446229506 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 46468880 | 10.4% | |
| A | 24969779 | 5.6% |
| a | 22762692 | 5.1% |
| i | 22639415 | 5.1% |
| C | 19673973 | 4.4% |
| r | 18469298 | 4.1% |
| n | 18328273 | 4.1% |
| e | 17600154 | 3.9% |
| I | 16960889 | 3.8% |
| o | 16726088 | 3.7% |
| Other values (61) | 221630065 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 446229506 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 46468880 | 10.4% | |
| A | 24969779 | 5.6% |
| a | 22762692 | 5.1% |
| i | 22639415 | 5.1% |
| C | 19673973 | 4.4% |
| r | 18469298 | 4.1% |
| n | 18328273 | 4.1% |
| e | 17600154 | 3.9% |
| I | 16960889 | 3.8% |
| o | 16726088 | 3.7% |
| Other values (61) | 221630065 |
Item Number
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 0 |
|---|---|
| Missing (%) | 0.0% |
| Memory size | 854.7 MiB |
Item Description
Text
| Distinct | 10911 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.8 GiB |
Length
| Max length | 63 |
|---|---|
| Median length | 52 |
| Mean length | 20.979921 |
| Min length | 2 |
Characters and Unicode
| Total characters | 521298190 |
|---|---|
| Distinct characters | 87 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1137 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Templeton 4YR Rye |
|---|---|
| 2nd row | Dr McGillicuddys Cherry |
| 3rd row | Evan Williams Vintage |
| 4th row | Smirnoff Peppermint Twist |
| 5th row | Templeton Rye Rare Cask Strength |
| Value | Count | Frequency (%) |
| vodka | 4457394 | 5.4% |
| mini | 1995067 | 2.4% |
| rum | 1794303 | 2.2% |
| black | 1688907 | 2.1% |
| whiskey | 1375358 | 1.7% |
| spiced | 1197714 | 1.5% |
| crown | 1126861 | 1.4% |
| pet | 1086395 | 1.3% |
| velvet | 971338 | 1.2% |
| liqueur | 880339 | 1.1% |
| Other values (5103) | 65447005 |
Most occurring characters
| Value | Count | Frequency (%) |
| 57181604 | 11.0% | |
| a | 42706416 | 8.2% |
| e | 41239590 | 7.9% |
| i | 31446331 | 6.0% |
| r | 31154241 | 6.0% |
| o | 27157260 | 5.2% |
| n | 26456014 | 5.1% |
| l | 21490373 | 4.1% |
| s | 16448032 | 3.2% |
| d | 15303158 | 2.9% |
| Other values (77) | 210715171 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 521298190 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 57181604 | 11.0% | |
| a | 42706416 | 8.2% |
| e | 41239590 | 7.9% |
| i | 31446331 | 6.0% |
| r | 31154241 | 6.0% |
| o | 27157260 | 5.2% |
| n | 26456014 | 5.1% |
| l | 21490373 | 4.1% |
| s | 16448032 | 3.2% |
| d | 15303158 | 2.9% |
| Other values (77) | 210715171 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 521298190 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 57181604 | 11.0% | |
| a | 42706416 | 8.2% |
| e | 41239590 | 7.9% |
| i | 31446331 | 6.0% |
| r | 31154241 | 6.0% |
| o | 27157260 | 5.2% |
| n | 26456014 | 5.1% |
| l | 21490373 | 4.1% |
| s | 16448032 | 3.2% |
| d | 15303158 | 2.9% |
| Other values (77) | 210715171 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 521298190 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 57181604 | 11.0% | |
| a | 42706416 | 8.2% |
| e | 41239590 | 7.9% |
| i | 31446331 | 6.0% |
| r | 31154241 | 6.0% |
| o | 27157260 | 5.2% |
| n | 26456014 | 5.1% |
| l | 21490373 | 4.1% |
| s | 16448032 | 3.2% |
| d | 15303158 | 2.9% |
| Other values (77) | 210715171 |
Pack
Real number (ℝ)
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.204653 |
| Minimum | 1 |
|---|---|
| Maximum | 336 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 6 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 24 |
| Maximum | 336 |
| Range | 335 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 7.7094335 |
|---|---|
| Coefficient of variation (CV) | 0.63167985 |
| Kurtosis | 21.924377 |
| Mean | 12.204653 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.122434 |
| Sum | 3.0325489 × 108 |
| Variance | 59.435364 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 14108264 | |
| 6 | 6929906 | |
| 24 | 2251084 | 9.1% |
| 48 | 625906 | 2.5% |
| 10 | 490828 | 2.0% |
| 1 | 193894 | 0.8% |
| 8 | 76740 | 0.3% |
| 5 | 57258 | 0.2% |
| 44 | 41927 | 0.2% |
| 4 | 35532 | 0.1% |
| Other values (18) | 36142 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 193894 | 0.8% |
| 2 | 645 | < 0.1% |
| 3 | 27025 | 0.1% |
| 4 | 35532 | 0.1% |
| 5 | 57258 | 0.2% |
| 6 | 6929906 | |
| 8 | 76740 | 0.3% |
| 9 | 2050 | < 0.1% |
| 10 | 490828 | 2.0% |
| 12 | 14108264 |
| Value | Count | Frequency (%) |
| 336 | 13 | < 0.1% |
| 312 | 40 | < 0.1% |
| 288 | 101 | < 0.1% |
| 160 | 4 | < 0.1% |
| 120 | 5 | < 0.1% |
| 96 | 1 | < 0.1% |
| 80 | 9 | < 0.1% |
| 60 | 1265 | < 0.1% |
| 48 | 625906 | |
| 44 | 41927 | 0.2% |
Bottle Volume (ml)
Real number (ℝ)
SKEWED 
| Distinct | 58 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 892.22323 |
| Minimum | 0 |
|---|---|
| Maximum | 378000 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 200 |
| Q1 | 750 |
| median | 750 |
| Q3 | 1000 |
| 95-th percentile | 1750 |
| Maximum | 378000 |
| Range | 378000 |
| Interquartile range (IQR) | 250 |
Descriptive statistics
| Standard deviation | 639.17426 |
|---|---|
| Coefficient of variation (CV) | 0.7163838 |
| Kurtosis | 119468.83 |
| Mean | 892.22323 |
| Median Absolute Deviation (MAD) | 250 |
| Skewness | 207.80102 |
| Sum | 2.21695 × 1010 |
| Variance | 408543.74 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 750 | 11153324 | |
| 1750 | 4903124 | |
| 1000 | 3105652 | 12.5% |
| 375 | 2544998 | 10.2% |
| 200 | 879922 | 3.5% |
| 50 | 865857 | 3.5% |
| 500 | 730575 | 2.9% |
| 600 | 221220 | 0.9% |
| 100 | 175941 | 0.7% |
| 3000 | 95623 | 0.4% |
| Other values (48) | 171245 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 10 | < 0.1% |
| 12 | 1 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 1920 | < 0.1% |
| 25 | 253 | < 0.1% |
| 50 | 865857 | |
| 100 | 175941 | 0.7% |
| 150 | 793 | < 0.1% |
| 175 | 54 | < 0.1% |
| 200 | 879922 |
| Value | Count | Frequency (%) |
| 378000 | 24 | < 0.1% |
| 225000 | 1 | < 0.1% |
| 189000 | 2 | < 0.1% |
| 180000 | 2 | < 0.1% |
| 140000 | 8 | < 0.1% |
| 31500 | 24 | < 0.1% |
| 9000 | 3 | < 0.1% |
| 7580 | 1 | < 0.1% |
| 6000 | 1299 | |
| 5250 | 194 | < 0.1% |
State Bottle Cost
Real number (ℝ)
SKEWED 
| Distinct | 3377 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.265363 |
| Minimum | 0 |
|---|---|
| Maximum | 7680 |
| Zeros | 3084 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.96 |
| Q1 | 5.52 |
| median | 8.25 |
| Q3 | 12.5 |
| 95-th percentile | 23.48 |
| Maximum | 7680 |
| Range | 7680 |
| Interquartile range (IQR) | 6.98 |
Descriptive statistics
| Standard deviation | 11.043744 |
|---|---|
| Coefficient of variation (CV) | 1.075826 |
| Kurtosis | 83951.321 |
| Mean | 10.265363 |
| Median Absolute Deviation (MAD) | 3.24 |
| Skewness | 183.00903 |
| Sum | 2.5506831 × 108 |
| Variance | 121.96429 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8.25 | 493597 | 2.0% |
| 7.5 | 442179 | 1.8% |
| 10 | 422000 | 1.7% |
| 6.5 | 411121 | 1.7% |
| 5 | 332540 | 1.3% |
| 11 | 268716 | 1.1% |
| 8 | 257565 | 1.0% |
| 7 | 255836 | 1.0% |
| 3.5 | 254111 | 1.0% |
| 6 | 248874 | 1.0% |
| Other values (3367) | 21460932 |
| Value | Count | Frequency (%) |
| 0 | 3084 | < 0.1% |
| 0.19 | 1 | < 0.1% |
| 0.33 | 15 | < 0.1% |
| 0.43 | 7 | < 0.1% |
| 0.48 | 1 | < 0.1% |
| 0.51 | 1 | < 0.1% |
| 0.55 | 1 | < 0.1% |
| 0.59 | 1 | < 0.1% |
| 0.66 | 2 | < 0.1% |
| 0.89 | 18060 |
| Value | Count | Frequency (%) |
| 7680 | 1 | < 0.1% |
| 6468 | 2 | < 0.1% |
| 6100 | 2 | < 0.1% |
| 6000 | 4 | < 0.1% |
| 5800 | 9 | < 0.1% |
| 5500 | 1 | < 0.1% |
| 3537.3 | 24 | |
| 2298.84 | 1 | < 0.1% |
| 2250 | 11 | |
| 2249.97 | 1 | < 0.1% |
State Bottle Retail
Real number (ℝ)
SKEWED 
| Distinct | 3846 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.409941 |
| Minimum | 0 |
|---|---|
| Maximum | 11520 |
| Zeros | 3084 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4.44 |
| Q1 | 8.31 |
| median | 12.38 |
| Q3 | 18.75 |
| 95-th percentile | 35.22 |
| Maximum | 11520 |
| Range | 11520 |
| Interquartile range (IQR) | 10.44 |
Descriptive statistics
| Standard deviation | 16.564842 |
|---|---|
| Coefficient of variation (CV) | 1.0749452 |
| Kurtosis | 83966.495 |
| Mean | 15.409941 |
| Median Absolute Deviation (MAD) | 4.86 |
| Skewness | 183.03253 |
| Sum | 3.8289807 × 108 |
| Variance | 274.39399 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12.38 | 440414 | 1.8% |
| 11.25 | 416848 | 1.7% |
| 15 | 393457 | 1.6% |
| 9.75 | 357595 | 1.4% |
| 7.5 | 322103 | 1.3% |
| 12 | 253615 | 1.0% |
| 5.25 | 249031 | 1.0% |
| 16.5 | 246789 | 1.0% |
| 10.5 | 242173 | 1.0% |
| 13.5 | 233326 | 0.9% |
| Other values (3836) | 21692120 |
| Value | Count | Frequency (%) |
| 0 | 3084 | < 0.1% |
| 0.29 | 1 | < 0.1% |
| 0.5 | 15 | < 0.1% |
| 0.65 | 7 | < 0.1% |
| 0.72 | 1 | < 0.1% |
| 0.76 | 1 | < 0.1% |
| 0.83 | 1 | < 0.1% |
| 0.88 | 1 | < 0.1% |
| 0.99 | 2 | < 0.1% |
| 1.34 | 18060 |
| Value | Count | Frequency (%) |
| 11520 | 1 | < 0.1% |
| 9702 | 2 | < 0.1% |
| 9150 | 2 | < 0.1% |
| 9000 | 4 | < 0.1% |
| 8700 | 9 | < 0.1% |
| 8250 | 1 | < 0.1% |
| 5305.95 | 24 | |
| 3448.26 | 1 | < 0.1% |
| 3375 | 11 | |
| 3374.96 | 1 | < 0.1% |
Bottles Sold
Real number (ℝ)
SKEWED 
| Distinct | 692 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.636772 |
| Minimum | -240 |
|---|---|
| Maximum | 15000 |
| Zeros | 9 |
| Zeros (%) | < 0.1% |
| Negative | 400 |
| Negative (%) | < 0.1% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | -240 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 6 |
| Q3 | 12 |
| 95-th percentile | 24 |
| Maximum | 15000 |
| Range | 15240 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 29.505095 |
|---|---|
| Coefficient of variation (CV) | 2.7738768 |
| Kurtosis | 18435.701 |
| Mean | 10.636772 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 65.304444 |
| Sum | 2.6429699 × 108 |
| Variance | 870.55063 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 6570629 | |
| 6 | 5051881 | |
| 2 | 3238769 | |
| 1 | 2771696 | |
| 3 | 2423744 | 9.8% |
| 24 | 1429527 | 5.8% |
| 4 | 1335652 | 5.4% |
| 48 | 389102 | 1.6% |
| 5 | 311554 | 1.3% |
| 36 | 202301 | 0.8% |
| Other values (682) | 1122626 | 4.5% |
| Value | Count | Frequency (%) |
| -240 | 1 | < 0.1% |
| -156 | 1 | < 0.1% |
| -120 | 1 | < 0.1% |
| -72 | 2 | < 0.1% |
| -60 | 2 | < 0.1% |
| -48 | 14 | |
| -36 | 7 | < 0.1% |
| -30 | 4 | < 0.1% |
| -24 | 33 | |
| -18 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 15000 | 2 | |
| 13200 | 4 | |
| 11952 | 1 | < 0.1% |
| 11880 | 1 | < 0.1% |
| 11124 | 1 | < 0.1% |
| 7920 | 4 | |
| 7632 | 1 | < 0.1% |
| 7260 | 1 | < 0.1% |
| 7116 | 1 | < 0.1% |
| 6750 | 1 | < 0.1% |
Sale (Dollars)
Real number (ℝ)
SKEWED 
| Distinct | 31523 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 140.81338 |
| Minimum | -3375 |
|---|---|
| Maximum | 279557.28 |
| Zeros | 4943 |
| Zeros (%) | < 0.1% |
| Negative | 400 |
| Negative (%) | < 0.1% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | -3375 |
|---|---|
| 5-th percentile | 11.14 |
| Q1 | 33.6 |
| median | 74.28 |
| Q3 | 147.6 |
| 95-th percentile | 342.24 |
| Maximum | 279557.28 |
| Range | 282932.28 |
| Interquartile range (IQR) | 114 |
Descriptive statistics
| Standard deviation | 489.26328 |
|---|---|
| Coefficient of variation (CV) | 3.4745511 |
| Kurtosis | 30136.114 |
| Mean | 140.81338 |
| Median Absolute Deviation (MAD) | 49.47 |
| Skewness | 88.295247 |
| Sum | 3.4988563 × 109 |
| Variance | 239378.56 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 90 | 270962 | 1.1% |
| 135 | 224866 | 0.9% |
| 162 | 181797 | 0.7% |
| 148.56 | 181670 | 0.7% |
| 180 | 177391 | 0.7% |
| 64.8 | 174545 | 0.7% |
| 45 | 163792 | 0.7% |
| 126 | 148000 | 0.6% |
| 94.2 | 135410 | 0.5% |
| 72 | 132935 | 0.5% |
| Other values (31513) | 23056103 |
| Value | Count | Frequency (%) |
| -3375 | 1 | |
| -1656 | 1 | |
| -1439.52 | 1 | |
| -1394.7 | 1 | |
| -1348.8 | 1 | |
| -1170 | 1 | |
| -1124.4 | 1 | |
| -1080 | 1 | |
| -972 | 1 | |
| -890.64 | 1 |
| Value | Count | Frequency (%) |
| 279557.28 | 1 | < 0.1% |
| 254100 | 2 | |
| 250932 | 4 | |
| 225838.8 | 1 | < 0.1% |
| 196004.88 | 1 | < 0.1% |
| 181962 | 1 | < 0.1% |
| 156807 | 1 | < 0.1% |
| 150559.2 | 4 | |
| 145084.32 | 1 | < 0.1% |
| 130416 | 1 | < 0.1% |
Volume Sold (Liters)
Real number (ℝ)
SKEWED 
| Distinct | 1577 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.1722439 |
| Minimum | -156 |
|---|---|
| Maximum | 15000 |
| Zeros | 10 |
| Zeros (%) | < 0.1% |
| Negative | 400 |
| Negative (%) | < 0.1% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | -156 |
|---|---|
| 5-th percentile | 0.5 |
| Q1 | 1.5 |
| median | 4.8 |
| Q3 | 10.5 |
| 95-th percentile | 21 |
| Maximum | 15000 |
| Range | 15156 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 35.311108 |
|---|---|
| Coefficient of variation (CV) | 3.8497786 |
| Kurtosis | 12528.506 |
| Mean | 9.1722439 |
| Median Absolute Deviation (MAD) | 4.2 |
| Skewness | 65.3384 |
| Sum | 2.2790716 × 108 |
| Variance | 1246.8744 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 4812300 | |
| 10.5 | 3207479 | |
| 1.5 | 2048460 | 8.2% |
| 2.25 | 1720122 | 6.9% |
| 4.5 | 1511527 | 6.1% |
| 0.75 | 1482309 | 6.0% |
| 12 | 1456459 | 5.9% |
| 3 | 1147574 | 4.6% |
| 21 | 492224 | 2.0% |
| 1 | 454534 | 1.8% |
| Other values (1567) | 6514493 |
| Value | Count | Frequency (%) |
| -156 | 1 | < 0.1% |
| -63 | 2 | < 0.1% |
| -60 | 1 | < 0.1% |
| -54 | 2 | < 0.1% |
| -52.5 | 2 | < 0.1% |
| -48 | 2 | < 0.1% |
| -45 | 1 | < 0.1% |
| -36 | 5 | |
| -31.5 | 2 | < 0.1% |
| -27 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 15000 | 2 | |
| 13200 | 4 | |
| 11880 | 1 | < 0.1% |
| 11812.5 | 1 | < 0.1% |
| 11340 | 1 | < 0.1% |
| 11124 | 1 | < 0.1% |
| 8964 | 1 | < 0.1% |
| 8736 | 1 | < 0.1% |
| 8505 | 1 | < 0.1% |
| 8032.5 | 1 | < 0.1% |
Volume Sold (Gallons)
Real number (ℝ)
SKEWED 
| Distinct | 1875 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4208059 |
| Minimum | -41.21 |
|---|---|
| Maximum | 3962.58 |
| Zeros | 465 |
| Zeros (%) | < 0.1% |
| Negative | 400 |
| Negative (%) | < 0.1% |
| Memory size | 189.6 MiB |
Quantile statistics
| Minimum | -41.21 |
|---|---|
| 5-th percentile | 0.13 |
| Q1 | 0.4 |
| median | 1.27 |
| Q3 | 2.77 |
| 95-th percentile | 5.55 |
| Maximum | 3962.58 |
| Range | 4003.79 |
| Interquartile range (IQR) | 2.37 |
Descriptive statistics
| Standard deviation | 9.3282946 |
|---|---|
| Coefficient of variation (CV) | 3.8533839 |
| Kurtosis | 12528.031 |
| Mean | 2.4208059 |
| Median Absolute Deviation (MAD) | 1.1 |
| Skewness | 65.336529 |
| Sum | 60150929 |
| Variance | 87.01708 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.77 | 3207479 | 12.9% |
| 2.38 | 2745687 | 11.1% |
| 2.37 | 2066613 | 8.3% |
| 0.59 | 1720122 | 6.9% |
| 3.17 | 1456459 | 5.9% |
| 0.4 | 1279070 | 5.1% |
| 0.79 | 1147574 | 4.6% |
| 0.2 | 889135 | 3.6% |
| 1.18 | 815734 | 3.3% |
| 0.39 | 769411 | 3.1% |
| Other values (1865) | 8750197 |
| Value | Count | Frequency (%) |
| -41.21 | 1 | < 0.1% |
| -16.64 | 2 | < 0.1% |
| -15.85 | 1 | < 0.1% |
| -14.26 | 2 | < 0.1% |
| -13.86 | 2 | < 0.1% |
| -12.68 | 2 | < 0.1% |
| -11.88 | 1 | < 0.1% |
| -9.51 | 5 | |
| -8.32 | 2 | < 0.1% |
| -7.13 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 3962.58 | 2 | |
| 3487.07 | 4 | |
| 3138.36 | 1 | < 0.1% |
| 3120.53 | 1 | < 0.1% |
| 2995.71 | 1 | < 0.1% |
| 2938.65 | 1 | < 0.1% |
| 2368.03 | 1 | < 0.1% |
| 2307.8 | 1 | < 0.1% |
| 2246.78 | 1 | < 0.1% |
| 2121.96 | 1 | < 0.1% |